<?php
	include("../connect/connect.php");
	$sql = "delete from rev_militaryevent;";
	$rs=mysql_query($sql);
	$sql = "delete from rev_militaryvictim;";
	$rs=mysql_query($sql);
	$sql = "delete from rev_policeevent;";	
	$rs=mysql_query($sql);
	$sql = "delete from rev_policevictim;";
	$rs=mysql_query($sql);
	$sql = "delete from rev_visadmission_last;";
	$rs=mysql_query($sql);
	$sql = "delete from event where evnid > 15174;";
	$rs=mysql_query($sql);
	$sql = "delete from EVNRELEVNTYP where evnid > 15174;";
	$rs=mysql_query($sql);
	$sql = "delete from EVNSRC where evnid > 15174;";
	$rs=mysql_query($sql);
	$sql = "delete from person where perid > 36458;";
	$rs=mysql_query($sql);
	$sql = "delete from LOSOFPER where evnid > 15174;";
	$rs=mysql_query($sql);
	$sql = "update military.event set senddscc=0;";
	$rs=mysql_query($sql);
	$sql = "update military.victim set senddscc=0;";
	$rs=mysql_query($sql);
	$sql = "update police.event set senddscc=0;";
	$rs=mysql_query($sql);
	$sql = "update police.victim set senddscc=0;";
	$rs=mysql_query($sql);
	$sql = "update vis.admission_last set senddscc=0;";
	$rs=mysql_query($sql);
	$sql = "update vms.mentalhelp set senddscc=0;";
	$rs=mysql_query($sql);
	$sql = "update opm.opmhelp set senddscc=0;";
	$rs=mysql_query($sql);
	mysql_close($c);
	echo "<br><br>complete reset for testing getdata";
?>